package com.example.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.Emp;
import org.apache.ibatis.annotations.*;


import java.util.List;

@Mapper
public interface EmpMapper extends BaseMapper<Emp> {
    //添加
//    @Insert("insert into emp values(#{empno},#{ename},#{job},#{mgr},#{hiredate},#{sal},#{comm},#{deptno}) ")
//    int insertEmp(Emp emp);
//
//    //删除
//    @Delete("delete from emp where empno=#{empno}")
//    int deletById(int empno);
//
//    //改
////    @Update("update emp set ename = #{ename},job=#{job},mgr=#{mgr},hiredate = #{hiredate},sal=#{sal},comm = #{comm},deptno=#{deptno} where empno=#{empno};")
//    int updateEmp(Emp emp);
//    //查询
//    @Select("select * from emp")
//    List<Emp> findAll();
//
//    @Select("select * from emp where empno=#{empno}")
//    List<Emp> findById(Integer empno);
}
